SELECT C1.ID, C1.NAME, t.TITLE NAME1, C1.DESCRIPTION, C1.DISTRIBUTION,
C1.TAXON, C1.OBJID,
C1.AUTHORID AUID, au.NAME AUNAME, C1.AYEAR, C1.ABRACK, C1.AYEARREM,
C2.DETDESC DETDESC_FM, C2.ID C2ID, C2.NAME C2NAME, C2.NAME1 C2NAME1,
C1.ORIGSP,
C1.STATE_IDIMAGE, C1.TAXA_TYPE, C1.ORIGGEN, C1.ORIGSUBGEN,
ogn.NAME OGNNAME, osg.NAME OSGNAME,
gn.ID GNID, gn.NAME GNNAME, sgn.ID SGNID, sgn.NAME SGNNAME, C1.RANK,
(get_taxa_icon(C1.ID)) CLASS_ICONID, C1.TAXA_REMARK, C1.REFID, C1.TAXON,

(SELECT COUNT(*)
FROM (
SELECT MIN(ID) ID FROM articles a
WHERE a.CLASSID=1142
AND (a.DATE_TIME <> '' OR a.PLACE <> '')
GROUP BY a.DATE_TIME, a.PLACE
) as DS

)
DISTRCNT
FROM classes C1
LEFT JOIN
(SELECT t.OBJID TOBJID, c2.ID, c2.DETDESC, c2.NAME, c2.NAME1
from classobj_tree t
JOIN classes c2 ON c2.OBJID=t.POBJID AND c2.RANK=13
WHERE t.OBJID=
) as C2 on C2.TOBJID=C1.OBJID

LEFT JOIN c_author au ON au.ID=C1.AUTHORID
left join languages l on l.CODE='en'
left join titles t on t.LANGID=l.ID AND t.SIGNATURE='classes' and t.POBJID=C1.OBJID
left join classes ogn on ogn.ID = C1.ORIGGEN
left join classes osg on osg.ID = C1.ORIGSUBGEN
LEFT JOIN classes gn ON gn.OBJID =
(CASE WHEN C1.RANK=2
THEN (SELECT t.POBJID
FROM classobj_tree t
WHERE t.OBJID=C1.OBJID AND t.PRANK=7 LIMIT 1 )
ELSE NULL
END)
LEFT JOIN classes sgn ON sgn.OBJID =
(CASE WHEN C1.RANK=2
THEN (SELECT t.POBJID
FROM classobj_tree t
WHERE t.OBJID=C1.OBJID AND t.PRANK=6 LIMIT 1 )
ELSE NULL
END)
WHERE C1.ID=1142